CREATE TABLE [dbo].[Legis_Bills]
(
[BILL_ID] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Legis_Bills_BILL_ID] DEFAULT (''),
[BILL_TYPE] [varchar] (5) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Legis_Bills_BILL_TYPE] DEFAULT (''),
[COMPANION] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Legis_Bills_COMPANION] DEFAULT (''),
[AUTHOR_CODE] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Legis_Bills_AUTHOR_CODE] DEFAULT (''),
[AUTHOR_NAME] [varchar] (60) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Legis_Bills_AUTHOR_NAME] DEFAULT (''),
[COAUTHOR_CODE] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Legis_Bills_COAUTHOR_CODE] DEFAULT (''),
[COAUTHOR_NAME] [varchar] (60) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Legis_Bills_COAUTHOR_NAME] DEFAULT (''),
[SPONSOR_CODE] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Legis_Bills_SPONSOR_CODE] DEFAULT (''),
[SPONSOR_NAME] [varchar] (60) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Legis_Bills_SPONSOR_NAME] DEFAULT (''),
[TITLE] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Legis_Bills_TITLE] DEFAULT (''),
[STATUS] [varchar] (5) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Legis_Bills_STATUS] DEFAULT (''),
[LAST_ACTION] [varchar] (80) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Legis_Bills_LAST_ACTION] DEFAULT (''),
[LAST_ACTION_DATE] [datetime] NULL,
[SUBJECT_CODE] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Legis_Bills_SUBJECT_CODE] DEFAULT (''),
[CATEGORY] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Legis_Bills_CATEGORY] DEFAULT (''),
[SUBJECT] [varchar] (80) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Legis_Bills_SUBJECT] DEFAULT (''),
[SYNOPSIS] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ANALYSIS] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DATE_ADDED] [datetime] NULL,
[LAST_UPDATED] [datetime] NULL,
[UPDATED_BY] [varchar] (60) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Legis_Bills_UPDATED_BY] DEFAULT (''),
[BRIEFED] [bit] NOT NULL CONSTRAINT [DF_Legis_Bills_BRIEFED] DEFAULT ((0)),
[NOTES] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ACTION_HISTORY] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[UF1] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Legis_Bills_UF1] DEFAULT (''),
[UF2] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Legis_Bills_UF2] DEFAULT (''),
[UF3] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Legis_Bills_UF3] DEFAULT (''),
[UF4] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Legis_Bills_UF4] DEFAULT (''),
[UF5] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Legis_Bills_UF5] DEFAULT (''),
[UF6] [datetime] NULL,
[UF7] [datetime] NULL,
[UF8] [datetime] NULL,
[TIME_STAMP] [timestamp] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
CREATE NONCLUSTERED INDEX [iLegis_BillsAUTHOR_CODE] ON [dbo].[Legis_Bills] ([AUTHOR_CODE]) ON [PRIMARY]
GO
CREATE CLUSTERED INDEX [iLegis_BillsBILL_ID] ON [dbo].[Legis_Bills] ([BILL_ID]) ON [PRIMARY]
GO
GRANT REFERENCES ON  [dbo].[Legis_Bills] TO [IMIS]
GRANT SELECT ON  [dbo].[Legis_Bills] TO [IMIS]
GRANT INSERT ON  [dbo].[Legis_Bills] TO [IMIS]
GRANT DELETE ON  [dbo].[Legis_Bills] TO [IMIS]
GRANT UPDATE ON  [dbo].[Legis_Bills] TO [IMIS]
GO